-
Re: December Question of the Month - Join the conversation and receive a badge
So many great answers & comments in here! …I'd love to be an instant expert in history. (Like, all history - which I know a big big thing 😀) The little bits of history I've learned help to put al…6 · -
Re: Index Join Collect - gather list
@Michelle Maas — Ack - my fault; sorry! I mistyped the criteria reference in my example formula. If you're collecting values in Column B based on the value in Column A, you'll want to reference Colum…1 · -
Re: IF formula with multiple options
@brewhaha - Hi John! You can nest a string of IFs together. :) For example: IF([Your Column]@row="Option A", "Your Option A message", IF([Your Column]@row="Option B", &q…2 · -
Re: COUNTIF "Submitted" and ISDATE = 2024
Hi @Cindi Meche — I think you might want to use a COUNTIFS here, as you have two conditions: forms that are "Submitted" and those submitted in the year 2024. I was having difficulty using t…1 · -
Re: Sheets and Form and User want to View specific sheet
Hi again! I wasn't clear in my first response; my apologies! Please allow me to clarify: :) Users who should only have view access to one or more items in the workspace can be shared to the workspace…1 ·